create table email(
cssno number(10),
postno number(10),
name varchar2(15),
code number(15),
postman varchar2(30),
constraint post_pk primary key(postno)
);
create table guest(
cssno number(10),
guestno number(10),
gname number(15),
gcode number(15),
constraint gestno_pk primary key(guestno)
);
create table part(
cssno number(10),
pno number(15),
pname varchar2(30),
price number(15),
sto number(3),
constraint pno_pk primary key(pno)
);
create table order1(
cssno number(10),
reno number(5),			--주문번호
vol number(10), 		--주문량
bday date,
pday date,
dday date,
constraint reno_pk primary key(reno)
);

insert into email
values (exam.nextval, 111,'아야야',123-11,'아야야');
insert into guest
values (exam.nextval, 222, 22222, 222222)

